<?php
session_start();
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="style.css" />
<title>Wellcome to Charity Organization!</title>
</head>

<body>
<div id="container">
		<div id="header">
			<h1>Charity<span class="off">Organization</span></h1>
        </div>   
        <div id="menu">
			<ul>
				<a href="Insert.php">Back</a>
            </ul>
        </div>
    
		<div id="content">
        <div id="content_top"></div>
		<div id="content_main">
		<?php
			$link =mysql_connect('localhost','root','');
			if (!$link) {
				die('Not connected : ' . mysql_error());
			}
			$db_selected = mysql_select_db('seproject', $link);
			if (!$db_selected) {
				die ('Cannot useSeproject : ' . mysql_error());
			}
			$Category= $_POST["Category"];  $Price=$_POST["Price"]; $Description=$_POST["Description"];
		
			$query=mysql_query("SELECT Product_ID FROM `product`");
			$num=mysql_num_rows($query);
			for($i=0;$i<$num-1;$i++)
			{
				$a=mysql_fetch_row($query);
			}
			$last=mysql_fetch_row($query);
			$Product_ID='I'.($last[0][1]+1);
			
			$query1=mysql_query("INSERT INTO `seproject`.`product` (`Product_ID`, `Category`, `Price`,`Description`) VALUES ('$Product_ID', '$Category', '$Price', '$Description')");
			if($query1)
			{
				echo "Item has been inserted!";
				?>
				<a href="ManageStore.php">Back</a>
				<?php
			}
			else
			{
				echo "Insert item has been failed!";
				?>
				<a href="ManageStore.php">Back</a>
				<?php
			}	
			?>
        </div>
        <div id="content_bottom"></div>
      </div>
   </div>
</body>
</html>
